﻿CREATE PROCEDURE [dbo].[Designation_Delete]
@DesignationID uniqueidentifier
AS
BEGIN

UPDATE [dbo].[Designation]
SET [Deleted] = 1
WHERE [Deleted] = 0
AND [DesignationID] = @DesignationID


END
